CREATE VIEW [dbo].[vNameProspectUnion]
AS
SELECT ID, PREFIX, LAST_FIRST, FIRST_NAME, MIDDLE_NAME, LAST_NAME, SUFFIX,FULL_NAME, TITLE, COMPANY, COMPANY_SORT, CITY, STATE_PROVINCE, ZIP, COUNTRY, HOME_PHONE, WORK_PHONE, FAX, EMAIL, ORG_CODE, MEMBER_TYPE, CATEGORY, STATUS, MAJOR_KEY, CO_ID, BT_ID,  DUP_MATCH_KEY, FULL_ADDRESS, DESIGNATION, INFORMAL, TOLL_FREE, MAIL_CODE, CRRT, BAR_CODE,  COUNTY, MAIL_ADDRESS_NUM, BILL_ADDRESS_NUM, GENDER, BIRTH_DATE,US_CONGRESS, STATE_SENATE,  STATE_HOUSE, SIC_CODE, CHAPTER, FUNCTIONAL_TITLE, CONTACT_RANK, MEMBER_RECORD, COMPANY_RECORD,  JOIN_DATE, SOURCE_CODE, PAID_THRU, MEMBER_STATUS, MEMBER_STATUS_DATE, PREVIOUS_MT,  MT_CHANGE_DATE, CO_MEMBER_TYPE, EXCLUDE_MAIL, EXCLUDE_DIRECTORY, DATE_ADDED, LAST_UPDATED, UPDATED_BY, INTENT_TO_EDIT, ADDRESS_NUM_1, ADDRESS_NUM_2, ADDRESS_NUM_3, WEBSITE, '' AS ImisID,0 as IsProspect
FROM [Name]
UNION ALL
SELECT  ProspectID as ID, Prefix as PREFIX, LastFirst as LAST_FIRST, FirstName as FIRST_NAME, MiddleName as MIDDLE_NAME, LastName as LAST_NAME, Suffix as SUFFIX, FullName as FULL_NAME, Title as TITLE, Organization as COMPANY, CompanySort as COMPANY_SORT, City as CITY,  StateProvince as STATE_PROVINCE, PostalCode as ZIP, Country as COUNTRY, HomePhone as HOME_PHONE,  WorkPhone as WORK_PHONE, Fax as FAX, Email as EMAIL, '' AS ORG_CODE, ListCode AS MEMBER_TYPE, '' AS CATEGORY, '' AS STATUS, '' AS MAJOR_KEY, '' AS CO_ID,   '' AS BT_ID, '' AS DUP_MATCH_KEY, '' AS FULL_ADDRESS, '' AS DESIGNATION, '' AS INFORMAL,  '' AS TOLL_FREE, '' AS MAIL_CODE, '' AS CRRT, '' AS BAR_CODE, '' AS COUNTY, 0 AS MAIL_ADDRESS_NUM,  0 AS BILL_ADDRESS_NUM, '' AS GENDER, NULL AS BIRTH_DATE, '' AS US_CONGRESS, '' AS STATE_SENATE,  '' AS STATE_HOUSE, '' AS SIC_CODE, '' AS CHAPTER, '' AS FUNCTIONAL_TITLE, 0 AS CONTACT_RANK, 0 AS MEMBER_RECORD,  0 AS COMPANY_RECORD, NULL AS JOIN_DATE, '' AS SOURCE_CODE, NULL AS PAID_THRU, '' AS MEMBER_STATUS,  NULL AS MEMBER_STATUS_DATE, '' AS PREVIOUS_MT, NULL AS MT_CHANGE_DATE, '' AS CO_MEMBER_TYPE, 0 AS EXCLUDE_MAIL,  0 AS EXCLUDE_DIRECTORY, NULL AS DATE_ADDED, NULL AS LAST_UPDATED, '' AS UPDATED_BY, '' AS INTENT_TO_EDIT,  0 AS ADDRESS_NUM_1, 0 AS ADDRESS_NUM_2, 0 AS ADDRESS_NUM_3, '' AS WEBSITE, ImisID,1 as IsProspect
FROM [Prospect]

GO
GRANT REFERENCES ON  [dbo].[vNameProspectUnion] TO [IMIS]
GRANT SELECT ON  [dbo].[vNameProspectUnion] TO [IMIS]
GRANT INSERT ON  [dbo].[vNameProspectUnion] TO [IMIS]
GRANT DELETE ON  [dbo].[vNameProspectUnion] TO [IMIS]
GRANT UPDATE ON  [dbo].[vNameProspectUnion] TO [IMIS]
GO